<?php 

return array (
  'table' => 
  array (
    1 => 'CREATE TABLE IF NOT EXISTS `{tablename}` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `catid` smallint(5) unsigned NOT NULL COMMENT \'栏目id\',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT \'主题\',
  `zhiding` tinyint(1) DEFAULT \'0\' COMMENT \'置顶\',
  `thumb` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT \'缩略图\',
  `keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT \'关键字\',
  `description` text COLLATE utf8mb4_unicode_ci COMMENT \'描述\',
  `content` mediumtext COLLATE utf8mb4_unicode_ci COMMENT \'内容\',
  `hits` int(10) unsigned DEFAULT NULL COMMENT \'浏览数\',
  `uid` int(10) unsigned NOT NULL COMMENT \'作者id\',
  `author` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT \'笔名\',
  `status` tinyint(2) NOT NULL COMMENT \'状态(已废弃)\',
  `link_id` int(10) NOT NULL DEFAULT \'0\' COMMENT \'同步id\',
  `tableid` smallint(5) unsigned NOT NULL COMMENT \'附表id\',
  `inputip` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT \'录入者ip\',
  `inputtime` int(10) unsigned NOT NULL COMMENT \'录入时间\',
  `updatetime` int(10) unsigned NOT NULL COMMENT \'更新时间\',
  `displayorder` int(10) DEFAULT \'0\' COMMENT \'排序值\',
  `qunxin_total` int(10) unsigned DEFAULT \'0\' COMMENT \'表单群信统计\',
  `tupian` text COLLATE utf8mb4_unicode_ci COMMENT \'图片\',
  `shipin` text COLLATE utf8mb4_unicode_ci COMMENT \'视频\',
  `yuyin` text COLLATE utf8mb4_unicode_ci COMMENT \'语音\',
  `fujian` text COLLATE utf8mb4_unicode_ci COMMENT \'附件\',
  `yidu` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT \'已读\',
  `faxinren` int(10) DEFAULT \'0\' COMMENT \'发信人\',
  `shouxinren` int(10) DEFAULT \'0\' COMMENT \'收信人\',
  `hylb_total` int(10) unsigned DEFAULT \'0\' COMMENT \'表单好友列表统计\',
  `qylb_total` int(10) unsigned DEFAULT \'0\' COMMENT \'表单群友列表统计\',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT \'url\',
  `quanziid` int(10) DEFAULT \'0\' COMMENT \'圈子ID\',
  `quantieid` int(10) DEFAULT \'0\' COMMENT \'圈贴ID\',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `catid` (`catid`),
  KEY `link_id` (`link_id`),
  KEY `status` (`status`),
  KEY `updatetime` (`updatetime`),
  KEY `hits` (`hits`),
  KEY `category` (`catid`,`status`),
  KEY `displayorder` (`displayorder`),
  KEY `qunxin_total` (`qunxin_total`),
  KEY `hylb_total` (`hylb_total`),
  KEY `qylb_total` (`qylb_total`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT=\'内容主表\'',
    0 => 'CREATE TABLE IF NOT EXISTS `{tablename}` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` mediumint(8) unsigned NOT NULL COMMENT \'作者uid\',
  `catid` smallint(5) unsigned NOT NULL COMMENT \'栏目id\',
  UNIQUE KEY `id` (`id`),
  KEY `uid` (`uid`),
  KEY `catid` (`catid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT=\'内容附表\'',
  ),
  'field' => 
  array (
    1 => 
    array (
      0 => 
      array (
        'name' => '主题',
        'fieldname' => 'title',
        'fieldtype' => 'Text',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '1',
        'ismember' => '0',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'fieldtype' => 'VARCHAR',
            'fieldlength' => '255',
            'value' => '',
            'width' => '400',
            'css' => '',
          ),
          'validate' => 
          array (
            'xss' => '1',
            'required' => '0',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'tips' => '',
            'formattr' => 'onblur="check_title();get_keywords(\'keywords\');"',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
      1 => 
      array (
        'name' => '缩略图',
        'fieldname' => 'thumb',
        'fieldtype' => 'File',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '1',
        'ismember' => '0',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'ext' => 'jpg,gif,png',
            'size' => 10,
            'width' => 400,
            'fieldtype' => 'VARCHAR',
            'fieldlength' => '255',
          ),
        ),
        'displayorder' => '0',
      ),
      2 => 
      array (
        'name' => '关键字',
        'fieldname' => 'keywords',
        'fieldtype' => 'Text',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '1',
        'ismember' => '0',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'width' => 400,
            'fieldtype' => 'VARCHAR',
            'fieldlength' => '255',
          ),
          'validate' => 
          array (
            'xss' => 1,
            'formattr' => ' data-role="tagsinput"',
          ),
        ),
        'displayorder' => '0',
      ),
      3 => 
      array (
        'name' => '描述',
        'fieldname' => 'description',
        'fieldtype' => 'Textarea',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '1',
        'ismember' => '0',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'width' => 500,
            'height' => 60,
            'fieldtype' => 'VARCHAR',
            'fieldlength' => '255',
          ),
          'validate' => 
          array (
            'xss' => 1,
            'filter' => 'dr_filter_description',
          ),
        ),
        'displayorder' => '0',
      ),
      4 => 
      array (
        'name' => '笔名',
        'fieldname' => 'author',
        'fieldtype' => 'Text',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '1',
        'ismember' => '0',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'is_right' => 1,
          'option' => 
          array (
            'width' => 200,
            'fieldtype' => 'VARCHAR',
            'fieldlength' => '255',
            'value' => '{name}',
          ),
          'validate' => 
          array (
            'xss' => 1,
          ),
        ),
        'displayorder' => '0',
      ),
      5 => 
      array (
        'name' => '文字信息',
        'fieldname' => 'content',
        'fieldtype' => 'Editor',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '1',
        'ismember' => '1',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'show_bottom_boot' => '1',
            'imgtitle' => '0',
            'imgalt' => '0',
            'watermark' => '0',
            'image_ext' => 'jpg,gif,png,webp,jpeg',
            'image_size' => '10',
            'attach_size' => '200',
            'attach_ext' => 'zip,rar,txt,doc',
            'video_ext' => 'mp4',
            'video_size' => '500',
            'attachment' => '0',
            'value' => '',
            'width' => '100%',
            'height' => '400',
            'css' => '',
          ),
          'validate' => 
          array (
            'xss' => '1',
            'required' => '1',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'tips' => '',
            'formattr' => '',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
      6 => 
      array (
        'name' => '置顶',
        'fieldname' => 'zhiding',
        'fieldtype' => 'Radio',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '0',
        'ismember' => '0',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'options' => '不置顶|0
置顶|1',
            'value' => '0',
            'fieldtype' => 'TINYINT',
            'fieldlength' => '1',
            'show_type' => '0',
            'css' => '',
          ),
          'validate' => 
          array (
            'xss' => '1',
            'required' => '0',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'formattr' => '',
            'tips' => '',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
      7 => 
      array (
        'name' => '图片',
        'fieldname' => 'tupian',
        'fieldtype' => 'Filesjiugetu',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '0',
        'ismember' => '1',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'size' => '50',
            'count' => '50',
            'ext' => 'jpg,gif,png,webp',
            'attachment' => '0',
            'image_reduce' => '1000',
            'is_ext_tips' => '0',
            'css' => '',
          ),
          'validate' => 
          array (
            'xss' => '1',
            'required' => '0',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'tips' => '',
            'formattr' => '',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
      8 => 
      array (
        'name' => '视频',
        'fieldname' => 'shipin',
        'fieldtype' => 'Files',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '0',
        'ismember' => '1',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'size' => '100',
            'count' => '10',
            'ext' => 'mp3,wan,mp4',
            'attachment' => '0',
            'image_reduce' => '',
            'is_ext_tips' => '0',
            'css' => '',
          ),
          'validate' => 
          array (
            'required' => '0',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'tips' => '',
            'formattr' => '',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
      9 => 
      array (
        'name' => '语音',
        'fieldname' => 'yuyin',
        'fieldtype' => 'Filesyuyin',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '0',
        'ismember' => '1',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'size' => '100',
            'count' => '2',
            'ext' => 'mp3,wan',
            'attachment' => '0',
            'image_reduce' => '',
            'is_ext_tips' => '0',
            'css' => '',
          ),
          'validate' => 
          array (
            'xss' => '1',
            'required' => '0',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'tips' => '',
            'formattr' => '',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
      10 => 
      array (
        'name' => '附件',
        'fieldname' => 'fujian',
        'fieldtype' => 'Files',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '0',
        'ismember' => '1',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'size' => '100',
            'count' => '10',
            'ext' => 'rar,zip',
            'attachment' => '0',
            'image_reduce' => '',
            'is_ext_tips' => '0',
            'css' => '',
          ),
          'validate' => 
          array (
            'xss' => '1',
            'required' => '0',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'tips' => '',
            'formattr' => '',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
      11 => 
      array (
        'name' => '已读',
        'fieldname' => 'yidu',
        'fieldtype' => 'Radio',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '0',
        'ismember' => '1',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'options' => '未读|1
已读|2',
            'is_field_ld' => '0',
            'value' => '',
            'fieldtype' => '',
            'fieldlength' => '',
            'show_type' => '0',
            'css' => '',
          ),
          'validate' => 
          array (
            'xss' => '1',
            'required' => '0',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'tips' => '',
            'formattr' => '',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
      12 => 
      array (
        'name' => '发信人',
        'fieldname' => 'faxinren',
        'fieldtype' => 'Text',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '0',
        'ismember' => '1',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'fieldtype' => 'INT',
            'fieldlength' => '10',
            'value' => '',
            'width' => '',
            'css' => '',
          ),
          'validate' => 
          array (
            'xss' => '1',
            'required' => '0',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'tips' => '',
            'formattr' => '',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
      13 => 
      array (
        'name' => '收信人',
        'fieldname' => 'shouxinren',
        'fieldtype' => 'Text',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '0',
        'ismember' => '1',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'fieldtype' => 'INT',
            'fieldlength' => '10',
            'value' => '',
            'width' => '',
            'css' => '',
          ),
          'validate' => 
          array (
            'xss' => '1',
            'required' => '0',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'tips' => '',
            'formattr' => '',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
      14 => 
      array (
        'name' => 'url',
        'fieldname' => 'url',
        'fieldtype' => 'Textarea',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '0',
        'ismember' => '1',
        'issearch' => '1',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'value' => '',
            'fieldtype' => 'VARCHAR',
            'fieldlength' => '255',
            'width' => '',
            'height' => '',
            'css' => '',
          ),
          'validate' => 
          array (
            'xss' => '1',
            'required' => '0',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'tips' => '',
            'formattr' => '',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
      15 => 
      array (
        'name' => '圈子ID',
        'fieldname' => 'quanziid',
        'fieldtype' => 'Text',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '0',
        'ismember' => '1',
        'issearch' => '0',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'fieldtype' => 'INT',
            'fieldlength' => '10',
            'value' => '',
            'width' => '',
            'css' => '',
          ),
          'validate' => 
          array (
            'xss' => '1',
            'required' => '0',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'tips' => '',
            'formattr' => '',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
      16 => 
      array (
        'name' => '圈贴ID',
        'fieldname' => 'quantieid',
        'fieldtype' => 'Text',
        'isedit' => '1',
        'ismain' => '1',
        'issystem' => '0',
        'ismember' => '1',
        'issearch' => '0',
        'disabled' => '0',
        'setting' => 
        array (
          'option' => 
          array (
            'fieldtype' => 'INT',
            'fieldlength' => '10',
            'value' => '',
            'width' => '',
            'css' => '',
          ),
          'validate' => 
          array (
            'xss' => '1',
            'required' => '0',
            'pattern' => '',
            'errortips' => '',
            'check' => '',
            'filter' => '',
            'tips' => '',
            'formattr' => '',
          ),
          'is_right' => '0',
        ),
        'displayorder' => '0',
      ),
    ),
  ),
);